package org.dromara.system.mapper;

import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import org.dromara.common.mybatis.core.page.TableDataInfo;
import org.dromara.system.domain.WbProvince;
import org.dromara.system.domain.dto.WbCompanyBlacklistCountProvinceDTO;
import org.dromara.system.domain.dto.WbProvinceDTO;
import org.dromara.system.domain.vo.WbProvinceVo;
import org.dromara.common.mybatis.core.mapper.BaseMapperPlus;
import org.apache.ibatis.annotations.Param;

import java.util.Collection;
import java.util.List;

/**
 * 省份Mapper接口
 *
 * @author Lion Li
 * @date 2024-04-12
 */
public interface WbProvinceMapper extends BaseMapperPlus<WbProvince, WbProvinceVo> {

    Long selectName(@Param("provinceName") String provinceName);

    List<WbCompanyBlacklistCountProvinceDTO> selectProvinceBlacklistNum(  String companyName);

    Page<WbProvinceVo> getProvincesWithCitiesAndDistricts(@Param("dto") WbProvinceDTO dto, @Param("page") Page<Object> build);

    Integer selectSonNum(Collection<Long> provinceIds);
}
